﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using SalePartial.Model;
using System.Data;
using System.Data.SqlClient;

namespace SalePartial.IDAL
{
    public interface IXPInquiry
    {
        int Delete(Guid InquiryID);

        int DeleteByAddressID(Guid AddressID);

        int DeleteByCompanyID(Guid CompanyID);

        int DeleteByUserID(Guid UserID);

        int DeleteDynamic(string v_whereCondition);

        int Insert(XPInquiryInfo info);

        DataSet SelectAll();

        DataSet SelectByAddressID(Guid AddressID);

        DataSet SelectByCompanyID(Guid CompanyID);

        DataSet SelectByUserID(Guid UserID);

        DataSet SelectDynamic(string v_whereCondition, string v_orderByExpression);

        DataSet SelectPaged();

        SqlDataReader SelectReader(Guid InquiryID);

        SqlDataReader SelectReaderByAddressID(Guid AddressID);

        SqlDataReader SelectReaderByCompanyID(Guid CompanyID);

        SqlDataReader SelectReaderByUserID(Guid UserID);

        DataSet SelectSingle(Guid InquiryID);

        int Update(XPInquiryInfo info);
    }
}
